create or replace
TRIGGER TEAMS_TRIGGER
BEFORE INSERT ON TEAMS
FOR EACH ROW WHEN (NEW.TEAM_ID IS NULL)
BEGIN 
	SELECT TEAMS_SEQ.NEXTVAL 
	INTO :NEW.TEAM_ID 
	FROM DUAL;
END;